SQL Server Reports

Report Name	Description
All jobs	Displays all scheduled SQL Server jobs and the job owner, organized by server.
Backup history	Displays the backup start date, type, and device used for the backup for a specified database for a set number of days.
Backup status	Displays the database name, date of the last backup, days since the last backup, and the type of backup performed.
Current lock report	Displays any locks on the server, including the database name, object or index name, type of lock, resource, mode, and status.
Database configuration options	Displays configuration options for each database on the specified server.
Database settings	Displays any common options and their values for all the databases on your server.
Database user details	Displays the user name, roles, objects, granted/denied status, and column permissions for each database.
Display errors	Displays a log file without entries for log backups. This is useful when you have a number of log backup entries and you need to locate non-backup errors.
Drive space usage	Displays space for all databases on the server, including free space, space used, maximum size, and growth type.
Foreign key sequence	Displays tables in the order you can either populate or delete from them without violating any foreign key constraints. Objects with the lowest wave number indicate that they can be deleted with the fewest number of foreign key references. Objects with the highest wave number should be populated first.
Index description	(SQL Server 2000 only) Displays all indexes for the current database sorted by table. Index information includes whether it is clustered, unique, index keys, and the index size. run frequency, and the maximum duration.
Job details	(SQL Server 2000 only) Displays all SQL Server jobs, including whether they are scheduled, enabled, start date and time,
Row count for tables with clustered index	Displays the number of rows for all tables on a server that contain a clustered index.
Total rows and space used	Displays the total number of rows and space used for each table or view in the current database, including the reserved rows, unused rows, and index size. This report is sorted in descending order by reserved rows.
User permissions	Displays users permissions, grouped by role name and object type.

All jobs

Displays all scheduled SQL Server jobs and the job owner, organized by server.

Backup history

Displays the backup start date, type, and device used for the backup for a specified database for a set number of days.

Backup status

Displays the database name, date of the last backup, days since the last backup, and the type of backup performed.

Current lock report

Displays any locks on the server, including the database name, object or index name, type of lock, resource, mode, and status.

Database configuration options

Displays configuration options for each database on the specified server.

Database settings

Displays any common options and their values for all the databases on your server.

Database user details

Displays the user name, roles, objects, granted/denied status, and column permissions for each database.

Display errors

Displays a log file without entries for log backups. This is useful when you have a number of log backup entries and you need to locate non-backup errors.

Drive space usage

Displays space for all databases on the server, including free space, space used, maximum size, and growth type.

Foreign key sequence

Displays tables in the order you can either populate or delete from them without violating any foreign key constraints. Objects with the lowest wave number indicate that they can be deleted with the fewest number of foreign key references. Objects with the highest wave number should be populated first.

Index description

(SQL Server 2000 only) Displays all indexes for the current database sorted by table. Index information includes whether it is clustered, unique, index keys, and the index size. run frequency, and the maximum duration.

Job details

(SQL Server 2000 only) Displays all SQL Server jobs, including whether they are scheduled, enabled, start date and time,

Row count for tables with clustered index

Displays the number of rows for all tables on a server that contain a clustered index.

Total rows and space used

Displays the total number of rows and space used for each table or view in the current database, including the reserved rows, unused rows, and index size. This report is sorted in descending order by reserved rows.

User permissions

Displays users permissions, grouped by role name and object type.

Report Name	Description
Configuration change history	Displays a history of all sp_configure and Trace Flag Changes recorded by the default trace.
Schema change history	Displays a history of all committed DDL statement executions recorded by the default trace.

Report Name	Description
Indexes	Displays index information for a selected table, including whether the index is clustered, unique, ignores duplicate keys, allows page/row locks, and a list of indexed columns.
Non-indexed tables	Displays any tables that have not been indexed for the selected database.
Table constraints	Displays any check constraints for a selected table, including whether the constraint is enabled, valid data, and affected columns.
Table extended properties	Displays any extended properties for a selected table.
Table relationships	Displays any foreign key constraints for a selected table, including whether the constraint is enabled, referenced tables, and referenced keys.
Tables and columns	Displays all columns for a selected table, including the data type, default value, whether it allows null values, and for SQL Server 2005 any extended properties.
Tables and indexes	Displays any indexes for a selected table, including the name, columns included in the index, and whether it is unique or clustered.